package com.ruoyi.hr.mapper.welfare.welfareopen;

import com.ruoyi.hr.domain.Authority;
import com.ruoyi.hr.domain.welfare.welfareopen.WelfareOpen;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface WelfareOpenMapper {
    int findCount(WelfareOpen welfareOpen);
    List<WelfareOpen> findData(@Param("welfareOpen") WelfareOpen welfareOpen,@Param("authorities") List<Authority> authorities,@Param("isAdmin") int isAdmin);
    WelfareOpen findWelfareOpen(int id);

    //有没有社保数据
    int findsbCount(int id);
    //修改社保数据
    int updatesbXvalue(WelfareOpen welfareOpen);
    //新增社保数据
    int insertsbXvalue(WelfareOpen welfareOpen);

    //有没有公积金数据
    int findgjjCount(int id);
    //修改公积金数据
    int updategjjXvalue(WelfareOpen welfareOpen);
    //新增公积金数据
    int insertgjjXvalue(WelfareOpen welfareOpen);


    int updateWelfareOpen(WelfareOpen welfareOpen);

    List<List<Map<String, Object>>> executeProcedure(@Param("sql") String sql);
    List<WelfareOpen> findDataByIds(@Param("ids") String ids);

}
